Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$ACCESS

`V$ACCESS` displays information about locks that are currently imposed on library cache objects. The locks are imposed to ensure that they are not aged out of the library cache while they are required for SQL execution.

Column | Datatype | Description
--- | --- | ---
`SID` | `NUMBER` | Session number that is accessing an object
`OWNER` | `VARCHAR2(64)` | Owner of the object
`OBJECT` | `VARCHAR2(1000)` | Name of the object
`TYPE` | `VARCHAR2(24)` | Type identifier for the object